MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

29 rows where Object Name = 6075

View and edit SQL

Suggested facets: Is Public Domain, Culture, Artist Role, Artist Nationality, Object Date, Object Begin Date, Object End Date, Medium, Credit Line

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Repository
69333 C.I.37.46.57 0 0 82664 Costume Institute 8 Dolman 6075 Dolman American or European 48                           ca. 1894 1889 1899 [no medium available] 15100   Gift of Miss Irene Lewisohn, 1937                           Metropolitan Museum of Art, New York, NY 1
69335 C.I.38.103 0 1 82673 Costume Institute 8 Dolman 6075 Dolman American 1                           1885–89 1885 1889 silk 15101   Gift of Aline Bernstein, 1938                           Metropolitan Museum of Art, New York, NY 1
70603 C.I.38.102 0 1 84581 Costume Institute 8 Dolman 6075 Dolman American 1                           ca. 1870 1865 1875 silk 15101   Gift of Mrs. George W. Heller, 1938                           Metropolitan Museum of Art, New York, NY 1
79053 49.3.13 0 0 105408 Costume Institute 8 Dolman 6075 Dolman French 7         Design House 209   House of Worth French, 1858–1956   Worth, House of 5575 French 2 1858 1956 1905–10 1905 1910 wool, metallic thread 16262   Gift of Orme Wilson and R. Thornton Wilson, in memory of their mother, Mrs. Caroline Schermerhorn Astor Wilson, 1949                           Metropolitan Museum of Art, New York, NY 1
79408 1980.171.2 0 0 106549 Costume Institute 8 Dolman 6075 Dolman French 7         Design House|Designer 198   House of Worth|Charles Frederick Worth French, 1858–1956|French (born England), Bourne 1825–1895 Paris   Worth, House of|Worth, Charles Frederick 5708 French|French 21 1858 |1825 1956 |1895 1885–90 1885 1890 silk 15101   The Jacqueline Loewe Fowler Costume Collection, Gift of Jacqueline Loewe Fowler, 1980                           Metropolitan Museum of Art, New York, NY 1
79594 1979.346.95 0 1 106944 Costume Institute 8 Dolman 6075 Dolman American or European 48                           1883–89 1883 1889 silk 15101   Gift of The New York Historical Society, 1979                           Metropolitan Museum of Art, New York, NY 1
79596 1982.348.2 0 1 106946 Costume Institute 8 Dolman 6075 Dolman American 1                           ca. 1883 1878 1888 wool, silk 15161   Gift of Roi M. White, 1982                           Metropolitan Museum of Art, New York, NY 1
79600 C.I.55.58 0 1 106952 Costume Institute 8 Dolman 6075 Dolman American 1                           1880s 1880 1889 silk 15101   Gift of Mrs. Theodore H. Joseph, 1955                           Metropolitan Museum of Art, New York, NY 1
79661 C.I.45.95.4 0 1 107057 Costume Institute 8 Dolman 6075 Dolman American 1                           1886–88 1886 1888 silk 15101   Gift of Mrs. William Glenn, 1945                           Metropolitan Museum of Art, New York, NY 1
79970 1979.339.1 0 1 107601 Costume Institute 8 Dolman 6075 Dolman probably American 40                           1885–90 1885 1890 silk 15101   Gift of Mrs. Ripley Quinby, 1979                           Metropolitan Museum of Art, New York, NY 1
79976 1979.346.96 0 1 107610 Costume Institute 8 Dolman 6075 Dolman American 1                           ca. 1871 1866 1876 silk 15101   Gift of The New York Historical Society, 1979                           Metropolitan Museum of Art, New York, NY 1
80022 C.I.39.29 0 1 107699 Costume Institute 8 Dolman 6075 Dolman American or European 48                           1880s 1880 1889 silk 15101   Gift of Miss Ethel Seisfeld, 1939                           Metropolitan Museum of Art, New York, NY 1
80027 C.I.40.25.2 0 1 107716 Costume Institute 8 Dolman 6075 Dolman American or European 48                           1865–75 1865 1875 wool 15104   Gift of Mrs. Louis G. Smith, 1940                           Metropolitan Museum of Art, New York, NY 1
80044 C.I.41.74.1 0 1 107746 Costume Institute 8 Dolman 6075 Dolman American or European 48                           1885–89 1885 1889 silk 15101   Gift of Mrs. Arthur Francis, 1941                           Metropolitan Museum of Art, New York, NY 1
80064 C.I.47.2.1 0 1 107792 Costume Institute 8 Dolman 6075 Dolman American 1                           ca. 1887 1882 1892 [no medium available] 15100   Gift of Miss A. Gladys Peck, 1947                           Metropolitan Museum of Art, New York, NY 1
80096 C.I.53.51.11 0 1 107836 Costume Institute 8 Dolman 6075 Dolman American 1                           1880s 1880 1889 cotton 3340   Gift of Mrs. Clyde R. Keith, 1953                           Metropolitan Museum of Art, New York, NY 1
80108 C.I.55.59 0 1 107853 Costume Institute 8 Dolman 6075 Dolman American 1                           1800–1875 1875 1800 wool, silk, glass 15562   Gift of Miss Miriam W. Donnelly, 1955                           Metropolitan Museum of Art, New York, NY 1
80133 C.I.63.51 0 1 107884 Costume Institute 8 Dolman 6075 Dolman French 7                           ca. 1890 1885 1895 silk 15101   Gift of Mrs. Thomas Campau, 1963                           Metropolitan Museum of Art, New York, NY 1
80351 C.I.40.84 0 1 108208 Costume Institute 8 Dolman 6075 Dolman British 6                           1860s 1860 1869 wool 15104   Gift of Mrs. DeWitt Clinton Cohen, 1940                           Metropolitan Museum of Art, New York, NY 1
92781 2009.300.472 0 1 159007 Costume Institute 8 Dolman 6075 Dolman American 1                           ca. 1885 1883 1887 silk 15101   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mrs. Robert G. Olmsted and Constable MacCracken, 1969                           Metropolitan Museum of Art, New York, NY 1
92978 2009.300.65 0 1 159204 Costume Institute 8 Dolman 6075 Dolman American 1         Department Store 208   Arnold Constable & Company American   Constable & Company, Arnold 7380 American 1     1870–80 1870 1880 wool, silk 15161   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mrs. Alfred S. Rossin, 1927                           Metropolitan Museum of Art, New York, NY 1
93200 2009.300.85 0 1 159426 Costume Institute 8 Dolman 6075 Dolman American 1                           ca. 1875 1870 1880 wool, silk 15161   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mrs. Clarence L. Fabre, 1933                           Metropolitan Museum of Art, New York, NY 1
93244 2009.300.89 0 1 159470 Costume Institute 8 Dolman 6075 Dolman American 1                           1885–90 1885 1890 silk 15101   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mrs. William Hamlin Childs, 1940                           Metropolitan Museum of Art, New York, NY 1
93333 2009.300.97 0 1 159559 Costume Institute 8 Dolman 6075 Dolman American 1                           ca. 1870 1868 1872 wool 15104   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Claire Lorraine Wilson, 1942                           Metropolitan Museum of Art, New York, NY 1
93373 2010.487.1 0 1 159717 Costume Institute 8 Dolman 6075 Dolman French 7         Designer 5   Emile Pingat French, active 1860–96   Pingat Emile 5762 French 2 1860 1896 1880s 1880 1889 silk, linen 15099   Gift of Christopher Scholz and Ines Elskop, 2010                           Metropolitan Museum of Art, New York, NY 1
96144 2009.300.6279 0 1 173326 Costume Institute 8 Dolman 6075 Dolman French 7         Designer 5   Compagnie Lyonnaise French   Compagnie Lyonnaise 7735 French 2     ca. 1880 1878 1882 Wool, silk 16397   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Lillian E. Glenn Peirce and Mabel Glenn Cooper, 1929                           Metropolitan Museum of Art, New York, NY 1
96146 2009.300.6281 0 1 173328 Costume Institute 8 Dolman 6075 Dolman American 1                           1870–79 1870 1879 Wool, silk, linen 20207   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Lillian E. Glenn Peirce and Mabel Glenn Cooper, 1929                           Metropolitan Museum of Art, New York, NY 1
96347 2009.300.6516 0 1 173529 Costume Institute 8 Dolman 6075 Dolman American 1                           1870–80 1870 1880 Wool, silk 16397   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Frank Sherman Benson Fund, 1944                           Metropolitan Museum of Art, New York, NY 1
96398 2009.300.6581 0 1 173580 Costume Institute 8 Dolman 6075 Dolman American 1                           1860–70 1860 1870 Wool, silk, metallic 19981   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Bequest of Matilda Alice Shaw, 1948                           Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 145.495ms · Data license: CC0 · Data source: metmuseum/openaccess